package com.isoft.dao;

import com.isoft.entity.CommonMeta;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

/**
 * @author LiuGaoMing
 * @version 1.0
 * @description:Meta表数据层
 * @date 2024/6/26 20:59
 */
@Mapper
public interface CommonMetaDao {

//    查询所有SEQN
    @Select("select * from TEAM04.COMMON_META where SEQN = #{SEQN}")
    CommonMeta selectAllSEQN(Integer SEQN);
//    插入数据
    @Insert("INSERT INTO TEAM04.COMMON_META(DDTM,TYPE,STYP,CREATE_TIME,SNDR,SEQN) VALUES(#{DDTM},#{TYPE},#{STYP},#{CREATETIME},#{SNDR},#{SEQN})")
    int insertCommonMeta(CommonMeta commonMeta);
//    根据SEQN删除
    @Delete("delete from TEAM04.COMMON_META where SEQN=#{SEQN}")
    int deleteCommonMeta(Integer SEQN);
}
